Re: [SQL] String concat operator??? - Mailing list pgsql-sql

From Herouth Maoz
Subject Re: [SQL] String concat operator???
Date
Msg-id l03130304b39fcd381882@[147.233.159.109]
Whole thread Raw
In response to String concat operator???  (webmaster <webmaster@tony.cz>)
Responses Re: [SQL] String concat operator???
List pgsql-sql
At 16:16 +0300 on 30/06/1999, webmaster wrote:


> Both id_look and ident are varchars.. So what's wrong with || operator? There
> is an error parsing the querry near || ...
>
> Who is stupid? Me, or postgresql 6.4.2 :) ? It look like legal expression for
> me...

Old problem... "||" doesn't have associativity, so when you use a||b||c, it
gets mixed up. Solution - use (a||b) || c. Preferably ((a||b)||c).

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma




pgsql-sql by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: [SQL] Port?
Next
From: Tom Lane
Date:
Subject: Re: [SQL] String concat operator???